03. Quiz: Spreadsheet Functions
Functions
QUIZ QUESTION::
Match the following functions with definitions. You may need to use use "help" in your spreadsheet application or look in the Formulas menu to find out more about these functions.
ANSWER CHOICES:
|
Definition |
Function |
|---|---|
TRIM(text) |
|
STDEV(n1, n2, …) |
|
UPPER(text) |
|
LEN(text) |
|
SUM(n1, n2, …) |
|
TRUE() |
SOLUTION:
|
Definition |
Function |
|---|---|
|
TRIM(text) |
|
|
STDEV(n1, n2, …) |
|
|
UPPER(text) |
|
|
LEN(text) |
|
|
SUM(n1, n2, …) |
|
|
TRUE() |